package com.applesweet.team.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class ConsumerExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ConsumerExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andConsumerIdIsNull() {
            addCriterion("consumer_id is null");
            return (Criteria) this;
        }

        public Criteria andConsumerIdIsNotNull() {
            addCriterion("consumer_id is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerIdEqualTo(Integer value) {
            addCriterion("consumer_id =", value, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerIdNotEqualTo(Integer value) {
            addCriterion("consumer_id <>", value, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerIdGreaterThan(Integer value) {
            addCriterion("consumer_id >", value, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("consumer_id >=", value, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerIdLessThan(Integer value) {
            addCriterion("consumer_id <", value, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerIdLessThanOrEqualTo(Integer value) {
            addCriterion("consumer_id <=", value, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerIdIn(List<Integer> values) {
            addCriterion("consumer_id in", values, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerIdNotIn(List<Integer> values) {
            addCriterion("consumer_id not in", values, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerIdBetween(Integer value1, Integer value2) {
            addCriterion("consumer_id between", value1, value2, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerIdNotBetween(Integer value1, Integer value2) {
            addCriterion("consumer_id not between", value1, value2, "consumerId");
            return (Criteria) this;
        }

        public Criteria andConsumerTelIsNull() {
            addCriterion("consumer_tel is null");
            return (Criteria) this;
        }

        public Criteria andConsumerTelIsNotNull() {
            addCriterion("consumer_tel is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerTelEqualTo(String value) {
            addCriterion("consumer_tel =", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelNotEqualTo(String value) {
            addCriterion("consumer_tel <>", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelGreaterThan(String value) {
            addCriterion("consumer_tel >", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_tel >=", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelLessThan(String value) {
            addCriterion("consumer_tel <", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelLessThanOrEqualTo(String value) {
            addCriterion("consumer_tel <=", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelLike(String value) {
            addCriterion("consumer_tel like", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelNotLike(String value) {
            addCriterion("consumer_tel not like", value, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelIn(List<String> values) {
            addCriterion("consumer_tel in", values, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelNotIn(List<String> values) {
            addCriterion("consumer_tel not in", values, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelBetween(String value1, String value2) {
            addCriterion("consumer_tel between", value1, value2, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerTelNotBetween(String value1, String value2) {
            addCriterion("consumer_tel not between", value1, value2, "consumerTel");
            return (Criteria) this;
        }

        public Criteria andConsumerNameIsNull() {
            addCriterion("consumer_name is null");
            return (Criteria) this;
        }

        public Criteria andConsumerNameIsNotNull() {
            addCriterion("consumer_name is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerNameEqualTo(String value) {
            addCriterion("consumer_name =", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameNotEqualTo(String value) {
            addCriterion("consumer_name <>", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameGreaterThan(String value) {
            addCriterion("consumer_name >", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_name >=", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameLessThan(String value) {
            addCriterion("consumer_name <", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameLessThanOrEqualTo(String value) {
            addCriterion("consumer_name <=", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameLike(String value) {
            addCriterion("consumer_name like", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameNotLike(String value) {
            addCriterion("consumer_name not like", value, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameIn(List<String> values) {
            addCriterion("consumer_name in", values, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameNotIn(List<String> values) {
            addCriterion("consumer_name not in", values, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameBetween(String value1, String value2) {
            addCriterion("consumer_name between", value1, value2, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerNameNotBetween(String value1, String value2) {
            addCriterion("consumer_name not between", value1, value2, "consumerName");
            return (Criteria) this;
        }

        public Criteria andConsumerVipIsNull() {
            addCriterion("consumer_vip is null");
            return (Criteria) this;
        }

        public Criteria andConsumerVipIsNotNull() {
            addCriterion("consumer_vip is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerVipEqualTo(Integer value) {
            addCriterion("consumer_vip =", value, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerVipNotEqualTo(Integer value) {
            addCriterion("consumer_vip <>", value, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerVipGreaterThan(Integer value) {
            addCriterion("consumer_vip >", value, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerVipGreaterThanOrEqualTo(Integer value) {
            addCriterion("consumer_vip >=", value, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerVipLessThan(Integer value) {
            addCriterion("consumer_vip <", value, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerVipLessThanOrEqualTo(Integer value) {
            addCriterion("consumer_vip <=", value, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerVipIn(List<Integer> values) {
            addCriterion("consumer_vip in", values, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerVipNotIn(List<Integer> values) {
            addCriterion("consumer_vip not in", values, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerVipBetween(Integer value1, Integer value2) {
            addCriterion("consumer_vip between", value1, value2, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerVipNotBetween(Integer value1, Integer value2) {
            addCriterion("consumer_vip not between", value1, value2, "consumerVip");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureIsNull() {
            addCriterion("consumer_picture is null");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureIsNotNull() {
            addCriterion("consumer_picture is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureEqualTo(String value) {
            addCriterion("consumer_picture =", value, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureNotEqualTo(String value) {
            addCriterion("consumer_picture <>", value, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureGreaterThan(String value) {
            addCriterion("consumer_picture >", value, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_picture >=", value, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureLessThan(String value) {
            addCriterion("consumer_picture <", value, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureLessThanOrEqualTo(String value) {
            addCriterion("consumer_picture <=", value, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureLike(String value) {
            addCriterion("consumer_picture like", value, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureNotLike(String value) {
            addCriterion("consumer_picture not like", value, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureIn(List<String> values) {
            addCriterion("consumer_picture in", values, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureNotIn(List<String> values) {
            addCriterion("consumer_picture not in", values, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureBetween(String value1, String value2) {
            addCriterion("consumer_picture between", value1, value2, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerPictureNotBetween(String value1, String value2) {
            addCriterion("consumer_picture not between", value1, value2, "consumerPicture");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeIsNull() {
            addCriterion("consumer_remind_time is null");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeIsNotNull() {
            addCriterion("consumer_remind_time is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeEqualTo(Date value) {
            addCriterionForJDBCDate("consumer_remind_time =", value, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("consumer_remind_time <>", value, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeGreaterThan(Date value) {
            addCriterionForJDBCDate("consumer_remind_time >", value, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("consumer_remind_time >=", value, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeLessThan(Date value) {
            addCriterionForJDBCDate("consumer_remind_time <", value, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("consumer_remind_time <=", value, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeIn(List<Date> values) {
            addCriterionForJDBCDate("consumer_remind_time in", values, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("consumer_remind_time not in", values, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("consumer_remind_time between", value1, value2, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerRemindTimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("consumer_remind_time not between", value1, value2, "consumerRemindTime");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsIsNull() {
            addCriterion("consumer_points is null");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsIsNotNull() {
            addCriterion("consumer_points is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsEqualTo(Integer value) {
            addCriterion("consumer_points =", value, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsNotEqualTo(Integer value) {
            addCriterion("consumer_points <>", value, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsGreaterThan(Integer value) {
            addCriterion("consumer_points >", value, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsGreaterThanOrEqualTo(Integer value) {
            addCriterion("consumer_points >=", value, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsLessThan(Integer value) {
            addCriterion("consumer_points <", value, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsLessThanOrEqualTo(Integer value) {
            addCriterion("consumer_points <=", value, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsIn(List<Integer> values) {
            addCriterion("consumer_points in", values, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsNotIn(List<Integer> values) {
            addCriterion("consumer_points not in", values, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsBetween(Integer value1, Integer value2) {
            addCriterion("consumer_points between", value1, value2, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerPointsNotBetween(Integer value1, Integer value2) {
            addCriterion("consumer_points not between", value1, value2, "consumerPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsIsNull() {
            addCriterion("consumer_total_points is null");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsIsNotNull() {
            addCriterion("consumer_total_points is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsEqualTo(Integer value) {
            addCriterion("consumer_total_points =", value, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsNotEqualTo(Integer value) {
            addCriterion("consumer_total_points <>", value, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsGreaterThan(Integer value) {
            addCriterion("consumer_total_points >", value, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsGreaterThanOrEqualTo(Integer value) {
            addCriterion("consumer_total_points >=", value, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsLessThan(Integer value) {
            addCriterion("consumer_total_points <", value, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsLessThanOrEqualTo(Integer value) {
            addCriterion("consumer_total_points <=", value, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsIn(List<Integer> values) {
            addCriterion("consumer_total_points in", values, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsNotIn(List<Integer> values) {
            addCriterion("consumer_total_points not in", values, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsBetween(Integer value1, Integer value2) {
            addCriterion("consumer_total_points between", value1, value2, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerTotalPointsNotBetween(Integer value1, Integer value2) {
            addCriterion("consumer_total_points not between", value1, value2, "consumerTotalPoints");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderIsNull() {
            addCriterion("consumer_gender is null");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderIsNotNull() {
            addCriterion("consumer_gender is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderEqualTo(String value) {
            addCriterion("consumer_gender =", value, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderNotEqualTo(String value) {
            addCriterion("consumer_gender <>", value, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderGreaterThan(String value) {
            addCriterion("consumer_gender >", value, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_gender >=", value, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderLessThan(String value) {
            addCriterion("consumer_gender <", value, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderLessThanOrEqualTo(String value) {
            addCriterion("consumer_gender <=", value, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderLike(String value) {
            addCriterion("consumer_gender like", value, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderNotLike(String value) {
            addCriterion("consumer_gender not like", value, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderIn(List<String> values) {
            addCriterion("consumer_gender in", values, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderNotIn(List<String> values) {
            addCriterion("consumer_gender not in", values, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderBetween(String value1, String value2) {
            addCriterion("consumer_gender between", value1, value2, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerGenderNotBetween(String value1, String value2) {
            addCriterion("consumer_gender not between", value1, value2, "consumerGender");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceIsNull() {
            addCriterion("consumer_introduce is null");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceIsNotNull() {
            addCriterion("consumer_introduce is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceEqualTo(String value) {
            addCriterion("consumer_introduce =", value, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceNotEqualTo(String value) {
            addCriterion("consumer_introduce <>", value, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceGreaterThan(String value) {
            addCriterion("consumer_introduce >", value, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_introduce >=", value, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceLessThan(String value) {
            addCriterion("consumer_introduce <", value, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceLessThanOrEqualTo(String value) {
            addCriterion("consumer_introduce <=", value, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceLike(String value) {
            addCriterion("consumer_introduce like", value, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceNotLike(String value) {
            addCriterion("consumer_introduce not like", value, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceIn(List<String> values) {
            addCriterion("consumer_introduce in", values, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceNotIn(List<String> values) {
            addCriterion("consumer_introduce not in", values, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceBetween(String value1, String value2) {
            addCriterion("consumer_introduce between", value1, value2, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerIntroduceNotBetween(String value1, String value2) {
            addCriterion("consumer_introduce not between", value1, value2, "consumerIntroduce");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailIsNull() {
            addCriterion("consumer_email is null");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailIsNotNull() {
            addCriterion("consumer_email is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailEqualTo(String value) {
            addCriterion("consumer_email =", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailNotEqualTo(String value) {
            addCriterion("consumer_email <>", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailGreaterThan(String value) {
            addCriterion("consumer_email >", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_email >=", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailLessThan(String value) {
            addCriterion("consumer_email <", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailLessThanOrEqualTo(String value) {
            addCriterion("consumer_email <=", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailLike(String value) {
            addCriterion("consumer_email like", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailNotLike(String value) {
            addCriterion("consumer_email not like", value, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailIn(List<String> values) {
            addCriterion("consumer_email in", values, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailNotIn(List<String> values) {
            addCriterion("consumer_email not in", values, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailBetween(String value1, String value2) {
            addCriterion("consumer_email between", value1, value2, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerEmailNotBetween(String value1, String value2) {
            addCriterion("consumer_email not between", value1, value2, "consumerEmail");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestIsNull() {
            addCriterion("consumer_interest is null");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestIsNotNull() {
            addCriterion("consumer_interest is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestEqualTo(String value) {
            addCriterion("consumer_interest =", value, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestNotEqualTo(String value) {
            addCriterion("consumer_interest <>", value, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestGreaterThan(String value) {
            addCriterion("consumer_interest >", value, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_interest >=", value, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestLessThan(String value) {
            addCriterion("consumer_interest <", value, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestLessThanOrEqualTo(String value) {
            addCriterion("consumer_interest <=", value, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestLike(String value) {
            addCriterion("consumer_interest like", value, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestNotLike(String value) {
            addCriterion("consumer_interest not like", value, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestIn(List<String> values) {
            addCriterion("consumer_interest in", values, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestNotIn(List<String> values) {
            addCriterion("consumer_interest not in", values, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestBetween(String value1, String value2) {
            addCriterion("consumer_interest between", value1, value2, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerInterestNotBetween(String value1, String value2) {
            addCriterion("consumer_interest not between", value1, value2, "consumerInterest");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeIsNull() {
            addCriterion("consumer_regtime is null");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeIsNotNull() {
            addCriterion("consumer_regtime is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeEqualTo(Date value) {
            addCriterionForJDBCDate("consumer_regtime =", value, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("consumer_regtime <>", value, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeGreaterThan(Date value) {
            addCriterionForJDBCDate("consumer_regtime >", value, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("consumer_regtime >=", value, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeLessThan(Date value) {
            addCriterionForJDBCDate("consumer_regtime <", value, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("consumer_regtime <=", value, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeIn(List<Date> values) {
            addCriterionForJDBCDate("consumer_regtime in", values, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("consumer_regtime not in", values, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("consumer_regtime between", value1, value2, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerRegtimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("consumer_regtime not between", value1, value2, "consumerRegtime");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusIsNull() {
            addCriterion("consumer_focus is null");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusIsNotNull() {
            addCriterion("consumer_focus is not null");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusEqualTo(String value) {
            addCriterion("consumer_focus =", value, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusNotEqualTo(String value) {
            addCriterion("consumer_focus <>", value, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusGreaterThan(String value) {
            addCriterion("consumer_focus >", value, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusGreaterThanOrEqualTo(String value) {
            addCriterion("consumer_focus >=", value, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusLessThan(String value) {
            addCriterion("consumer_focus <", value, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusLessThanOrEqualTo(String value) {
            addCriterion("consumer_focus <=", value, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusLike(String value) {
            addCriterion("consumer_focus like", value, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusNotLike(String value) {
            addCriterion("consumer_focus not like", value, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusIn(List<String> values) {
            addCriterion("consumer_focus in", values, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusNotIn(List<String> values) {
            addCriterion("consumer_focus not in", values, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusBetween(String value1, String value2) {
            addCriterion("consumer_focus between", value1, value2, "consumerFocus");
            return (Criteria) this;
        }

        public Criteria andConsumerFocusNotBetween(String value1, String value2) {
            addCriterion("consumer_focus not between", value1, value2, "consumerFocus");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}